IF EXISTS  
(      
SELECT 1      
FROM dbo.sysobjects      
WHERE id = OBJECT_ID(N'[dbo].[UpdateDrugPrice]')            
AND OBJECTPROPERTY(id, N'IsProcedure') = 1  )      
DROP PROCEDURE [dbo].[UpdateDrugPrice];